package com.waypolice.pojo;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class UpmsArchivesTypesExample implements Serializable {
    private static final long serialVersionUID = 1L;
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public UpmsArchivesTypesExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria implements Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andArchivesIdIsNull() {
            addCriterion("ARCHIVES_ID is null");
            return (Criteria) this;
        }

        public Criteria andArchivesIdIsNotNull() {
            addCriterion("ARCHIVES_ID is not null");
            return (Criteria) this;
        }

        public Criteria andArchivesIdEqualTo(Integer value) {
            addCriterion("ARCHIVES_ID =", value, "archivesId");
            return (Criteria) this;
        }

        public Criteria andArchivesIdNotEqualTo(Integer value) {
            addCriterion("ARCHIVES_ID <>", value, "archivesId");
            return (Criteria) this;
        }

        public Criteria andArchivesIdGreaterThan(Integer value) {
            addCriterion("ARCHIVES_ID >", value, "archivesId");
            return (Criteria) this;
        }

        public Criteria andArchivesIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ARCHIVES_ID >=", value, "archivesId");
            return (Criteria) this;
        }

        public Criteria andArchivesIdLessThan(Integer value) {
            addCriterion("ARCHIVES_ID <", value, "archivesId");
            return (Criteria) this;
        }

        public Criteria andArchivesIdLessThanOrEqualTo(Integer value) {
            addCriterion("ARCHIVES_ID <=", value, "archivesId");
            return (Criteria) this;
        }

        public Criteria andArchivesIdIn(List<Integer> values) {
            addCriterion("ARCHIVES_ID in", values, "archivesId");
            return (Criteria) this;
        }

        public Criteria andArchivesIdNotIn(List<Integer> values) {
            addCriterion("ARCHIVES_ID not in", values, "archivesId");
            return (Criteria) this;
        }

        public Criteria andArchivesIdBetween(Integer value1, Integer value2) {
            addCriterion("ARCHIVES_ID between", value1, value2, "archivesId");
            return (Criteria) this;
        }

        public Criteria andArchivesIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ARCHIVES_ID not between", value1, value2, "archivesId");
            return (Criteria) this;
        }

        public Criteria andSortNumIsNull() {
            addCriterion("SORT_NUM is null");
            return (Criteria) this;
        }

        public Criteria andSortNumIsNotNull() {
            addCriterion("SORT_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andSortNumEqualTo(String value) {
            addCriterion("SORT_NUM =", value, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumNotEqualTo(String value) {
            addCriterion("SORT_NUM <>", value, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumGreaterThan(String value) {
            addCriterion("SORT_NUM >", value, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumGreaterThanOrEqualTo(String value) {
            addCriterion("SORT_NUM >=", value, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumLessThan(String value) {
            addCriterion("SORT_NUM <", value, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumLessThanOrEqualTo(String value) {
            addCriterion("SORT_NUM <=", value, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumLike(String value) {
            addCriterion("SORT_NUM like", value, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumNotLike(String value) {
            addCriterion("SORT_NUM not like", value, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumIn(List<String> values) {
            addCriterion("SORT_NUM in", values, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumNotIn(List<String> values) {
            addCriterion("SORT_NUM not in", values, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumBetween(String value1, String value2) {
            addCriterion("SORT_NUM between", value1, value2, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNumNotBetween(String value1, String value2) {
            addCriterion("SORT_NUM not between", value1, value2, "sortNum");
            return (Criteria) this;
        }

        public Criteria andSortNameIsNull() {
            addCriterion("SORT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andSortNameIsNotNull() {
            addCriterion("SORT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andSortNameEqualTo(String value) {
            addCriterion("SORT_NAME =", value, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameNotEqualTo(String value) {
            addCriterion("SORT_NAME <>", value, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameGreaterThan(String value) {
            addCriterion("SORT_NAME >", value, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameGreaterThanOrEqualTo(String value) {
            addCriterion("SORT_NAME >=", value, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameLessThan(String value) {
            addCriterion("SORT_NAME <", value, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameLessThanOrEqualTo(String value) {
            addCriterion("SORT_NAME <=", value, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameLike(String value) {
            addCriterion("SORT_NAME like", value, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameNotLike(String value) {
            addCriterion("SORT_NAME not like", value, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameIn(List<String> values) {
            addCriterion("SORT_NAME in", values, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameNotIn(List<String> values) {
            addCriterion("SORT_NAME not in", values, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameBetween(String value1, String value2) {
            addCriterion("SORT_NAME between", value1, value2, "sortName");
            return (Criteria) this;
        }

        public Criteria andSortNameNotBetween(String value1, String value2) {
            addCriterion("SORT_NAME not between", value1, value2, "sortName");
            return (Criteria) this;
        }

        public Criteria andParentIdIsNull() {
            addCriterion("PARENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andParentIdIsNotNull() {
            addCriterion("PARENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andParentIdEqualTo(Integer value) {
            addCriterion("PARENT_ID =", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotEqualTo(Integer value) {
            addCriterion("PARENT_ID <>", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThan(Integer value) {
            addCriterion("PARENT_ID >", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("PARENT_ID >=", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLessThan(Integer value) {
            addCriterion("PARENT_ID <", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLessThanOrEqualTo(Integer value) {
            addCriterion("PARENT_ID <=", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdIn(List<Integer> values) {
            addCriterion("PARENT_ID in", values, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotIn(List<Integer> values) {
            addCriterion("PARENT_ID not in", values, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdBetween(Integer value1, Integer value2) {
            addCriterion("PARENT_ID between", value1, value2, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotBetween(Integer value1, Integer value2) {
            addCriterion("PARENT_ID not between", value1, value2, "parentId");
            return (Criteria) this;
        }

        public Criteria andLowerWidthIsNull() {
            addCriterion("LOWER_WIDTH is null");
            return (Criteria) this;
        }

        public Criteria andLowerWidthIsNotNull() {
            addCriterion("LOWER_WIDTH is not null");
            return (Criteria) this;
        }

        public Criteria andLowerWidthEqualTo(String value) {
            addCriterion("LOWER_WIDTH =", value, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthNotEqualTo(String value) {
            addCriterion("LOWER_WIDTH <>", value, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthGreaterThan(String value) {
            addCriterion("LOWER_WIDTH >", value, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthGreaterThanOrEqualTo(String value) {
            addCriterion("LOWER_WIDTH >=", value, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthLessThan(String value) {
            addCriterion("LOWER_WIDTH <", value, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthLessThanOrEqualTo(String value) {
            addCriterion("LOWER_WIDTH <=", value, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthLike(String value) {
            addCriterion("LOWER_WIDTH like", value, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthNotLike(String value) {
            addCriterion("LOWER_WIDTH not like", value, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthIn(List<String> values) {
            addCriterion("LOWER_WIDTH in", values, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthNotIn(List<String> values) {
            addCriterion("LOWER_WIDTH not in", values, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthBetween(String value1, String value2) {
            addCriterion("LOWER_WIDTH between", value1, value2, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andLowerWidthNotBetween(String value1, String value2) {
            addCriterion("LOWER_WIDTH not between", value1, value2, "lowerWidth");
            return (Criteria) this;
        }

        public Criteria andIsrootIsNull() {
            addCriterion("ISROOT is null");
            return (Criteria) this;
        }

        public Criteria andIsrootIsNotNull() {
            addCriterion("ISROOT is not null");
            return (Criteria) this;
        }

        public Criteria andIsrootEqualTo(String value) {
            addCriterion("ISROOT =", value, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootNotEqualTo(String value) {
            addCriterion("ISROOT <>", value, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootGreaterThan(String value) {
            addCriterion("ISROOT >", value, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootGreaterThanOrEqualTo(String value) {
            addCriterion("ISROOT >=", value, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootLessThan(String value) {
            addCriterion("ISROOT <", value, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootLessThanOrEqualTo(String value) {
            addCriterion("ISROOT <=", value, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootLike(String value) {
            addCriterion("ISROOT like", value, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootNotLike(String value) {
            addCriterion("ISROOT not like", value, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootIn(List<String> values) {
            addCriterion("ISROOT in", values, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootNotIn(List<String> values) {
            addCriterion("ISROOT not in", values, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootBetween(String value1, String value2) {
            addCriterion("ISROOT between", value1, value2, "isroot");
            return (Criteria) this;
        }

        public Criteria andIsrootNotBetween(String value1, String value2) {
            addCriterion("ISROOT not between", value1, value2, "isroot");
            return (Criteria) this;
        }

        public Criteria andFondsIdIsNull() {
            addCriterion("FONDS_ID is null");
            return (Criteria) this;
        }

        public Criteria andFondsIdIsNotNull() {
            addCriterion("FONDS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andFondsIdEqualTo(Integer value) {
            addCriterion("FONDS_ID =", value, "fondsId");
            return (Criteria) this;
        }

        public Criteria andFondsIdNotEqualTo(Integer value) {
            addCriterion("FONDS_ID <>", value, "fondsId");
            return (Criteria) this;
        }

        public Criteria andFondsIdGreaterThan(Integer value) {
            addCriterion("FONDS_ID >", value, "fondsId");
            return (Criteria) this;
        }

        public Criteria andFondsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("FONDS_ID >=", value, "fondsId");
            return (Criteria) this;
        }

        public Criteria andFondsIdLessThan(Integer value) {
            addCriterion("FONDS_ID <", value, "fondsId");
            return (Criteria) this;
        }

        public Criteria andFondsIdLessThanOrEqualTo(Integer value) {
            addCriterion("FONDS_ID <=", value, "fondsId");
            return (Criteria) this;
        }

        public Criteria andFondsIdIn(List<Integer> values) {
            addCriterion("FONDS_ID in", values, "fondsId");
            return (Criteria) this;
        }

        public Criteria andFondsIdNotIn(List<Integer> values) {
            addCriterion("FONDS_ID not in", values, "fondsId");
            return (Criteria) this;
        }

        public Criteria andFondsIdBetween(Integer value1, Integer value2) {
            addCriterion("FONDS_ID between", value1, value2, "fondsId");
            return (Criteria) this;
        }

        public Criteria andFondsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("FONDS_ID not between", value1, value2, "fondsId");
            return (Criteria) this;
        }

        public Criteria andCtimeIsNull() {
            addCriterion("CTIME is null");
            return (Criteria) this;
        }

        public Criteria andCtimeIsNotNull() {
            addCriterion("CTIME is not null");
            return (Criteria) this;
        }

        public Criteria andCtimeEqualTo(Date value) {
            addCriterionForJDBCDate("CTIME =", value, "ctime");
            return (Criteria) this;
        }

        public Criteria andCtimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("CTIME <>", value, "ctime");
            return (Criteria) this;
        }

        public Criteria andCtimeGreaterThan(Date value) {
            addCriterionForJDBCDate("CTIME >", value, "ctime");
            return (Criteria) this;
        }

        public Criteria andCtimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CTIME >=", value, "ctime");
            return (Criteria) this;
        }

        public Criteria andCtimeLessThan(Date value) {
            addCriterionForJDBCDate("CTIME <", value, "ctime");
            return (Criteria) this;
        }

        public Criteria andCtimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CTIME <=", value, "ctime");
            return (Criteria) this;
        }

        public Criteria andCtimeIn(List<Date> values) {
            addCriterionForJDBCDate("CTIME in", values, "ctime");
            return (Criteria) this;
        }

        public Criteria andCtimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("CTIME not in", values, "ctime");
            return (Criteria) this;
        }

        public Criteria andCtimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CTIME between", value1, value2, "ctime");
            return (Criteria) this;
        }

        public Criteria andCtimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CTIME not between", value1, value2, "ctime");
            return (Criteria) this;
        }

        public Criteria andMtimeIsNull() {
            addCriterion("MTIME is null");
            return (Criteria) this;
        }

        public Criteria andMtimeIsNotNull() {
            addCriterion("MTIME is not null");
            return (Criteria) this;
        }

        public Criteria andMtimeEqualTo(Date value) {
            addCriterionForJDBCDate("MTIME =", value, "mtime");
            return (Criteria) this;
        }

        public Criteria andMtimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("MTIME <>", value, "mtime");
            return (Criteria) this;
        }

        public Criteria andMtimeGreaterThan(Date value) {
            addCriterionForJDBCDate("MTIME >", value, "mtime");
            return (Criteria) this;
        }

        public Criteria andMtimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("MTIME >=", value, "mtime");
            return (Criteria) this;
        }

        public Criteria andMtimeLessThan(Date value) {
            addCriterionForJDBCDate("MTIME <", value, "mtime");
            return (Criteria) this;
        }

        public Criteria andMtimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("MTIME <=", value, "mtime");
            return (Criteria) this;
        }

        public Criteria andMtimeIn(List<Date> values) {
            addCriterionForJDBCDate("MTIME in", values, "mtime");
            return (Criteria) this;
        }

        public Criteria andMtimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("MTIME not in", values, "mtime");
            return (Criteria) this;
        }

        public Criteria andMtimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("MTIME between", value1, value2, "mtime");
            return (Criteria) this;
        }

        public Criteria andMtimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("MTIME not between", value1, value2, "mtime");
            return (Criteria) this;
        }

        public Criteria andStr1IsNull() {
            addCriterion("STR1 is null");
            return (Criteria) this;
        }

        public Criteria andStr1IsNotNull() {
            addCriterion("STR1 is not null");
            return (Criteria) this;
        }

        public Criteria andStr1EqualTo(String value) {
            addCriterion("STR1 =", value, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1NotEqualTo(String value) {
            addCriterion("STR1 <>", value, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1GreaterThan(String value) {
            addCriterion("STR1 >", value, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1GreaterThanOrEqualTo(String value) {
            addCriterion("STR1 >=", value, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1LessThan(String value) {
            addCriterion("STR1 <", value, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1LessThanOrEqualTo(String value) {
            addCriterion("STR1 <=", value, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1Like(String value) {
            addCriterion("STR1 like", value, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1NotLike(String value) {
            addCriterion("STR1 not like", value, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1In(List<String> values) {
            addCriterion("STR1 in", values, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1NotIn(List<String> values) {
            addCriterion("STR1 not in", values, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1Between(String value1, String value2) {
            addCriterion("STR1 between", value1, value2, "str1");
            return (Criteria) this;
        }

        public Criteria andStr1NotBetween(String value1, String value2) {
            addCriterion("STR1 not between", value1, value2, "str1");
            return (Criteria) this;
        }

        public Criteria andStr2IsNull() {
            addCriterion("STR2 is null");
            return (Criteria) this;
        }

        public Criteria andStr2IsNotNull() {
            addCriterion("STR2 is not null");
            return (Criteria) this;
        }

        public Criteria andStr2EqualTo(String value) {
            addCriterion("STR2 =", value, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2NotEqualTo(String value) {
            addCriterion("STR2 <>", value, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2GreaterThan(String value) {
            addCriterion("STR2 >", value, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2GreaterThanOrEqualTo(String value) {
            addCriterion("STR2 >=", value, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2LessThan(String value) {
            addCriterion("STR2 <", value, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2LessThanOrEqualTo(String value) {
            addCriterion("STR2 <=", value, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2Like(String value) {
            addCriterion("STR2 like", value, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2NotLike(String value) {
            addCriterion("STR2 not like", value, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2In(List<String> values) {
            addCriterion("STR2 in", values, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2NotIn(List<String> values) {
            addCriterion("STR2 not in", values, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2Between(String value1, String value2) {
            addCriterion("STR2 between", value1, value2, "str2");
            return (Criteria) this;
        }

        public Criteria andStr2NotBetween(String value1, String value2) {
            addCriterion("STR2 not between", value1, value2, "str2");
            return (Criteria) this;
        }

        public Criteria andStr3IsNull() {
            addCriterion("STR3 is null");
            return (Criteria) this;
        }

        public Criteria andStr3IsNotNull() {
            addCriterion("STR3 is not null");
            return (Criteria) this;
        }

        public Criteria andStr3EqualTo(String value) {
            addCriterion("STR3 =", value, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3NotEqualTo(String value) {
            addCriterion("STR3 <>", value, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3GreaterThan(String value) {
            addCriterion("STR3 >", value, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3GreaterThanOrEqualTo(String value) {
            addCriterion("STR3 >=", value, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3LessThan(String value) {
            addCriterion("STR3 <", value, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3LessThanOrEqualTo(String value) {
            addCriterion("STR3 <=", value, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3Like(String value) {
            addCriterion("STR3 like", value, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3NotLike(String value) {
            addCriterion("STR3 not like", value, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3In(List<String> values) {
            addCriterion("STR3 in", values, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3NotIn(List<String> values) {
            addCriterion("STR3 not in", values, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3Between(String value1, String value2) {
            addCriterion("STR3 between", value1, value2, "str3");
            return (Criteria) this;
        }

        public Criteria andStr3NotBetween(String value1, String value2) {
            addCriterion("STR3 not between", value1, value2, "str3");
            return (Criteria) this;
        }

        public Criteria andStr4IsNull() {
            addCriterion("STR4 is null");
            return (Criteria) this;
        }

        public Criteria andStr4IsNotNull() {
            addCriterion("STR4 is not null");
            return (Criteria) this;
        }

        public Criteria andStr4EqualTo(String value) {
            addCriterion("STR4 =", value, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4NotEqualTo(String value) {
            addCriterion("STR4 <>", value, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4GreaterThan(String value) {
            addCriterion("STR4 >", value, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4GreaterThanOrEqualTo(String value) {
            addCriterion("STR4 >=", value, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4LessThan(String value) {
            addCriterion("STR4 <", value, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4LessThanOrEqualTo(String value) {
            addCriterion("STR4 <=", value, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4Like(String value) {
            addCriterion("STR4 like", value, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4NotLike(String value) {
            addCriterion("STR4 not like", value, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4In(List<String> values) {
            addCriterion("STR4 in", values, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4NotIn(List<String> values) {
            addCriterion("STR4 not in", values, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4Between(String value1, String value2) {
            addCriterion("STR4 between", value1, value2, "str4");
            return (Criteria) this;
        }

        public Criteria andStr4NotBetween(String value1, String value2) {
            addCriterion("STR4 not between", value1, value2, "str4");
            return (Criteria) this;
        }

        public Criteria andStr5IsNull() {
            addCriterion("STR5 is null");
            return (Criteria) this;
        }

        public Criteria andStr5IsNotNull() {
            addCriterion("STR5 is not null");
            return (Criteria) this;
        }

        public Criteria andStr5EqualTo(String value) {
            addCriterion("STR5 =", value, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5NotEqualTo(String value) {
            addCriterion("STR5 <>", value, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5GreaterThan(String value) {
            addCriterion("STR5 >", value, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5GreaterThanOrEqualTo(String value) {
            addCriterion("STR5 >=", value, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5LessThan(String value) {
            addCriterion("STR5 <", value, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5LessThanOrEqualTo(String value) {
            addCriterion("STR5 <=", value, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5Like(String value) {
            addCriterion("STR5 like", value, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5NotLike(String value) {
            addCriterion("STR5 not like", value, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5In(List<String> values) {
            addCriterion("STR5 in", values, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5NotIn(List<String> values) {
            addCriterion("STR5 not in", values, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5Between(String value1, String value2) {
            addCriterion("STR5 between", value1, value2, "str5");
            return (Criteria) this;
        }

        public Criteria andStr5NotBetween(String value1, String value2) {
            addCriterion("STR5 not between", value1, value2, "str5");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria implements Serializable {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion implements Serializable {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}